----------------------------------------------------------------------------------------------------------------------------
      name:  <unnamed>
       log:  D:\Dropbox\Migration and Extreme Votes in France - Max & Paul\Data and Codes for submission - PSRM\Table 4.log
  log type:  text
 opened on:   1 Feb 2022, 16:50:22

. 
. clear

. 
. use "Table 4 dataset.dta"

. 
. 
. *************
. ***Table 4***
. ************* 
.  
. preserve

. foreach var of varlist log_tot_pop_  share_0014_     share_60p_  share_csp1_ share_csp2_ ///
> share_csp3_ share_csp4_ share_csp5_ share_csp6_ share_csp7_ share_csp8_ share_chom1564_  migshare_  log_median_inc_ female
> _ age_ right_  ///
> CSP_agri_ CSP_ind_ CSP_sal_ CSP_lib_ CSP_ens_ CSP_func_ CSP_div_ CSP_retr_  {
  2. 
. 
. drop if `var'==.
  3. 
. 
. }
(0 observations deleted)
(0 observations deleted)
(0 observations deleted)
(11 observations deleted)
(0 observations deleted)
(0 observations deleted)
(0 observations deleted)
(0 observations deleted)
(0 observations deleted)
(0 observations deleted)
(0 observations deleted)
(0 observations deleted)
(0 observations deleted)
(13,057 observations deleted)
(1,260 observations deleted)
(1,208 observations deleted)
(0 observations deleted)
(161 observations deleted)
(0 observations deleted)
(0 observations deleted)
(0 observations deleted)
(0 observations deleted)
(0 observations deleted)
(0 observations deleted)
(0 observations deleted)

. ***
. 
. keep if period>=2
(27,110 observations deleted)

. keep if log_fn!=.
(2 observations deleted)

. count
  58,066

. 
. foreach var of varlist  tx_creationette_2    {
  2.  
.  
.   ***Add control variables + FE***   
.  
. reg `var'  CAO_period_3 i.period   ///
> log_tot_pop_  share_0014_     share_60p_  share_csp1_ share_csp2_ ///
> share_csp3_ share_csp4_ share_csp5_ share_csp6_ share_csp7_ share_csp8_ share_chom1564_  migshare_  log_median_inc_ female
> _ age_ right_ ///
> CSP_agri_ CSP_ind_ CSP_sal_ CSP_lib_ CSP_ens_ CSP_func_ CSP_div_ CSP_retr_ , cluster( codeinsee) absorb(codeinsee)
  3.  
. qui outreg2 using "Table 4", ///
> keep(CAO_period_3) ctitle(`var', controls, time FE, municipal FE) bdec(3) nocons excel tex `append'
  4.   
.  
.  
.  }
note: share_csp8_ omitted because of collinearity
note: CSP_retr_ omitted because of collinearity

Linear regression, absorbing indicators         Number of obs     =     58,066
                                                F(24, 30051)      =          .
                                                Prob > F          =          .
                                                R-squared         =     0.5993
                                                Adj R-squared     =     0.1688
                                                Root MSE          =     11.279

                            (Std. Err. adjusted for 30,052 clusters in codeinsee)
---------------------------------------------------------------------------------
                |               Robust
tx_creationet~2 |      Coef.   Std. Err.      t    P>|t|     [95% Conf. Interval]
----------------+----------------------------------------------------------------
   CAO_period_3 |   2.335193   2.523006     0.93   0.355    -2.610007    7.280393
       3.period |   .2641715    .370388     0.71   0.476    -.4618049    .9901478
   log_tot_pop_ |   1.610522   3.095738     0.52   0.603    -4.457258    7.678303
    share_0014_ |   .7958761   7.415509     0.11   0.915    -13.73884    15.33059
     share_60p_ |  -3.592567   5.815293    -0.62   0.537    -14.99079    7.805656
    share_csp1_ |   4.755943    5.66002     0.84   0.401    -6.337939    15.84982
    share_csp2_ |   12.41758    6.36675     1.95   0.051    -.0615214    24.89669
    share_csp3_ |   9.000697   6.552806     1.37   0.170    -3.843085    21.84448
    share_csp4_ |   5.831864   4.253827     1.37   0.170    -2.505819    14.16955
    share_csp5_ |   3.611968   4.050063     0.89   0.372    -4.326329    11.55027
    share_csp6_ |   4.288061   3.073559     1.40   0.163    -1.736248    10.31237
    share_csp7_ |   7.708945   3.988746     1.93   0.053    -.1091683    15.52706
    share_csp8_ |          0  (omitted)
share_chom1564_ |  -1.719418   7.055992    -0.24   0.807    -15.54947    12.11063
      migshare_ |  -22.72233    23.5717    -0.96   0.335    -68.92388    23.47922
log_median_inc_ |   1.614696   2.439672     0.66   0.508    -3.167167    6.396558
        female_ |  -.6214356   1.002942    -0.62   0.536    -2.587244    1.344373
           age_ |  -.0559252   .1460204    -0.38   0.702    -.3421315     .230281
         right_ |  -.5416125   2.175633    -0.25   0.803    -4.805947    3.722722
      CSP_agri_ |  -.7600373   2.896253    -0.26   0.793    -6.436817    4.916743
       CSP_ind_ |   -2.91513   3.913637    -0.74   0.456    -10.58603    4.755766
       CSP_sal_ |  -.6204333   2.578142    -0.24   0.810    -5.673702    4.432836
       CSP_lib_ |   5.982984   7.642085     0.78   0.434     -8.99583     20.9618
       CSP_ens_ |   .0736265   2.304479     0.03   0.975    -4.443251    4.590504
      CSP_func_ |  -.7658462   6.215048    -0.12   0.902    -12.94761    11.41591
       CSP_div_ |   .3184995   2.338048     0.14   0.892    -4.264176    4.901175
      CSP_retr_ |          0  (omitted)
          _cons |  -25.91137   39.19341    -0.66   0.509    -102.7321     50.9094
---------------------------------------------------------------------------------
 : 
.  ***  
.   restore  

.  count  
  100,875

.   
. 
.  
.  reg log_fn  CAO_period_3 tx_creationette_2 i.period   ///
> log_tot_pop_  share_0014_     share_60p_  share_csp1_ share_csp2_ ///
> share_csp3_ share_csp4_ share_csp5_ share_csp6_ share_csp7_ share_csp8_ share_chom1564_  migshare_  log_median_inc_ female
> _ age_ right_ ///
> CSP_agri_ CSP_ind_ CSP_sal_ CSP_lib_ CSP_ens_ CSP_func_ CSP_div_ CSP_retr_, cluster( codeinsee) absorb(codeinsee)
note: share_csp8_ omitted because of collinearity
note: CSP_retr_ omitted because of collinearity

Linear regression, absorbing indicators         Number of obs     =     58,066
                                                F(25, 30051)      =          .
                                                Prob > F          =          .
                                                R-squared         =     0.9360
                                                Adj R-squared     =     0.8672
                                                Root MSE          =     .13042

                              (Std. Err. adjusted for 30,052 clusters in codeinsee)
-----------------------------------------------------------------------------------
                  |               Robust
           log_fn |      Coef.   Std. Err.      t    P>|t|     [95% Conf. Interval]
------------------+----------------------------------------------------------------
     CAO_period_3 |  -.0367001   .0119908    -3.06   0.002    -.0602025   -.0131976
tx_creationette_2 |   .0000697   .0000945     0.74   0.461    -.0001156     .000255
         3.period |   .2117189   .0041879    50.56   0.000     .2035105    .2199272
     log_tot_pop_ |   .0455339   .0463272     0.98   0.326    -.0452694    .1363373
      share_0014_ |   .3196084   .1425371     2.24   0.025     .0402296    .5989872
       share_60p_ |   -.257534   .1016766    -2.53   0.011    -.4568245   -.0582436
      share_csp1_ |  -.0676786   .1082623    -0.63   0.532    -.2798774    .1445203
      share_csp2_ |  -.0249089   .1035882    -0.24   0.810    -.2279463    .1781284
      share_csp3_ |  -.1917218   .0971881    -1.97   0.049    -.3822146    -.001229
      share_csp4_ |  -.0307048   .0728917    -0.42   0.674    -.1735757    .1121661
      share_csp5_ |  -.0246736   .0699532    -0.35   0.724    -.1617849    .1124376
      share_csp6_ |  -.0526596    .073559    -0.72   0.474    -.1968383    .0915192
      share_csp7_ |  -.0483154   .0656578    -0.74   0.462    -.1770076    .0803767
      share_csp8_ |          0  (omitted)
  share_chom1564_ |   .2685451   .1119725     2.40   0.016     .0490741     .488016
        migshare_ |  -.2083002   .2604465    -0.80   0.424    -.7187866    .3021861
  log_median_inc_ |  -.0644756   .0435023    -1.48   0.138    -.1497419    .0207907
          female_ |  -.0170712   .0249154    -0.69   0.493    -.0659064     .031764
             age_ |  -.0004949   .0015495    -0.32   0.749    -.0035319    .0025422
           right_ |  -.0167543   .0261327    -0.64   0.521    -.0679756     .034467
        CSP_agri_ |   .0261078   .0450549     0.58   0.562    -.0622017    .1144172
         CSP_ind_ |   .0231799   .0605007     0.38   0.702    -.0954039    .1417638
         CSP_sal_ |   .0091194   .0357516     0.26   0.799    -.0609552     .079194
         CSP_lib_ |   .0189867    .042111     0.45   0.652    -.0635526     .101526
         CSP_ens_ |   .0040108   .0627602     0.06   0.949    -.1190019    .1270234
        CSP_func_ |   .0381118   .0439773     0.87   0.386    -.0480857    .1243092
         CSP_div_ |   .0149877   .0444557     0.34   0.736    -.0721474    .1021228
        CSP_retr_ |          0  (omitted)
            _cons |   3.431797    .545649     6.29   0.000     2.362301    4.501292
-----------------------------------------------------------------------------------

.  
. qui outreg2 using "Table 4", ///
> keep(CAO_period_3 tx_creationette_2) ctitle(log_fn, controls, time FE, municipal FE) bdec(3) nocons excel tex `append'
 : 
.  
.  
.  
. preserve 

. 
. keep if period==3
(67,250 observations deleted)

. 
. 
. foreach var of varlist  CAO num_group_vv evol2_fn_2012_2017 /// 
> coastal  log_hotel_rooms    log_tot_pop_ delta_log_tot_pop  log_min_dist_center volontaires_migrants evol_CADA_2012_2016 s
> hare_0014_   share_60p_  delta_share_0014 ///
>    delta_share_60p   share_csp1_ share_csp2_ share_csp3_ share_csp4_ share_csp5_ share_csp6_ share_csp7_ share_csp8_   del
> ta_share_csp* share_chom1564_ delta_share_chom1564 migshare_ delta_migshare ///
>    log_median_inc_ delta_log_median_in female_ age_ right_ ///
>    CSP_agri_ CSP_ind_ CSP_sal_ CSP_lib_ CSP_ens_ CSP_func_ CSP_div_ CSP_retr_ {
  2. 
. 
. drop if `var'==.
  3. 
. }
(0 observations deleted)
(0 observations deleted)
(91 observations deleted)
(0 observations deleted)
(0 observations deleted)
(0 observations deleted)
(0 observations deleted)
(0 observations deleted)
(0 observations deleted)
(0 observations deleted)
(0 observations deleted)
(0 observations deleted)
(0 observations deleted)
(0 observations deleted)
(2 observations deleted)
(0 observations deleted)
(0 observations deleted)
(0 observations deleted)
(0 observations deleted)
(0 observations deleted)
(0 observations deleted)
(0 observations deleted)
(1 observation deleted)
(0 observations deleted)
(0 observations deleted)
(0 observations deleted)
(0 observations deleted)
(0 observations deleted)
(0 observations deleted)
(0 observations deleted)
(0 observations deleted)
(0 observations deleted)
(0 observations deleted)
(0 observations deleted)
(3,247 observations deleted)
(2,157 observations deleted)
(1,192 observations deleted)
(0 observations deleted)
(0 observations deleted)
(47 observations deleted)
(0 observations deleted)
(0 observations deleted)
(0 observations deleted)
(0 observations deleted)
(0 observations deleted)
(0 observations deleted)
(0 observations deleted)

. ***
.  
.   foreach var of varlist  tx_creationette_post_new  {
  2.   
.   
.  ivreg2  `var' (CAO= num_group_vv)   coastal  log_hotel_rooms    log_tot_pop_ delta_log_tot_pop  log_min_dist_center volon
> taires_migrants evol_CADA_2012_2016 share_0014_   share_60p_  delta_share_0014 ///
>    delta_share_60p   share_csp1_ share_csp2_ share_csp3_ share_csp4_ share_csp5_ share_csp6_ share_csp7_ share_csp8_   del
> ta_share_csp* share_chom1564_ delta_share_chom1564 migshare_ delta_migshare ///
>    log_median_inc_ delta_log_median_in female_ age_ right_ CSP_agri_ CSP_ind_ CSP_sal_ CSP_lib_ CSP_ens_ CSP_func_ CSP_div
> _ CSP_retr_  i.reg, cluster( numdep) first
  3. 
. qui outreg2 using "Table 4", ///
> keep(CAO) ctitle(IV, `var', all controls, regions FE) bdec(3) nocons excel tex addstat(F-statistic, e(widstat)) `append'
  4.   
.   
.   
.   }
Warning - collinearities detected
Vars dropped:       share_csp8_ delta_share_csp8 CSP_retr_

First-stage regressions
-----------------------


First-stage regression of CAO:

Statistics robust to heteroskedasticity and clustering on numdep
Number of obs =                  26888
Number of clusters (numdep) =       86
--------------------------------------------------------------------------------------
                     |               Robust
                 CAO |      Coef.   Std. Err.      t    P>|t|     [95% Conf. Interval]
---------------------+----------------------------------------------------------------
        num_group_vv |   .0046011   .0007181     6.41   0.000     .0031935    .0060086
             coastal |   .0208778   .0086708     2.41   0.016     .0038826    .0378729
     log_hotel_rooms |   .0045927    .000981     4.68   0.000     .0026698    .0065156
        log_tot_pop_ |   .0024107   .0011633     2.07   0.038     .0001305    .0046908
   delta_log_tot_pop |  -.0153752   .0068594    -2.24   0.025      -.02882   -.0019303
 log_min_dist_center |  -.0065344    .002394    -2.73   0.006    -.0112267   -.0018421
volontaires_migrants |   .0809558   .0245556     3.30   0.001     .0328256     .129086
 evol_CADA_2012_2016 |   .0018483    .000552     3.35   0.001     .0007664    .0029302
         share_0014_ |  -.0240424   .0264716    -0.91   0.364    -.0759281    .0278433
          share_60p_ |   -.015798   .0179238    -0.88   0.378    -.0509295    .0193335
    delta_share_0014 |   .0259118   .0169177     1.53   0.126    -.0072477    .0590713
     delta_share_60p |   .0009612   .0186736     0.05   0.959      -.03564    .0375624
         share_csp1_ |   .0085899   .0202451     0.42   0.671    -.0310914    .0482713
         share_csp2_ |  -.0523993   .0282438    -1.86   0.064    -.1077587    .0029601
         share_csp3_ |   -.020994   .0274623    -0.76   0.445    -.0748216    .0328336
         share_csp4_ |   .0126618   .0213899     0.59   0.554    -.0292636    .0545872
         share_csp5_ |   -.008885   .0216399    -0.41   0.681    -.0513003    .0335303
         share_csp6_ |   .0090731   .0198313     0.46   0.647    -.0297973    .0479436
         share_csp7_ |   .0012021   .0159143     0.08   0.940    -.0299907    .0323949
         share_csp8_ |          0  (omitted)
    delta_share_csp1 |  -.0229784   .0119184    -1.93   0.054    -.0463392    .0003823
    delta_share_csp2 |   .0155386   .0175948     0.88   0.377     -.018948    .0500253
    delta_share_csp3 |  -.0032451   .0169329    -0.19   0.848    -.0364345    .0299443
    delta_share_csp4 |  -.0273053   .0136821    -2.00   0.046     -.054123   -.0004877
    delta_share_csp5 |    -.00772   .0112152    -0.69   0.491    -.0297025    .0142625
    delta_share_csp6 |  -.0132011   .0125348    -1.05   0.292      -.03777    .0113679
    delta_share_csp7 |  -.0116526   .0100445    -1.16   0.246    -.0313404    .0080352
    delta_share_csp8 |          0  (omitted)
     share_chom1564_ |   .0443676    .029786     1.49   0.136    -.0140145    .1027497
delta_share_chom1564 |  -.0268875   .0243469    -1.10   0.269    -.0746088    .0208337
           migshare_ |   .0170946   .0283356     0.60   0.546    -.0384445    .0726338
      delta_migshare |     .01185   .0393755     0.30   0.763    -.0653279     .089028
     log_median_inc_ |  -.0115208   .0072118    -1.60   0.110    -.0256564    .0026147
delta_log_median_inc |  -.0078966   .0063384    -1.25   0.213    -.0203202     .004527
             female_ |  -.0001548   .0016196    -0.10   0.924    -.0033292    .0030196
                age_ |  -.0001664   .0001168    -1.42   0.154    -.0003953    .0000625
              right_ |  -.0009644   .0012366    -0.78   0.435    -.0033883    .0014595
           CSP_agri_ |  -.0002902   .0018495    -0.16   0.875    -.0039153    .0033348
            CSP_ind_ |   -.002377   .0028996    -0.82   0.412    -.0080604    .0033064
            CSP_sal_ |  -.0029104   .0021831    -1.33   0.182    -.0071894    .0013686
            CSP_lib_ |   .0005321   .0051859     0.10   0.918    -.0096325    .0106966
            CSP_ens_ |   .0025631    .004019     0.64   0.524    -.0053143    .0104405
           CSP_func_ |  -.0038623    .003055    -1.26   0.206    -.0098502    .0021256
            CSP_div_ |   .0040529   .0045307     0.89   0.371    -.0048275    .0129333
           CSP_retr_ |          0  (omitted)
                     |
                 reg |
             198234  |   .0076169   .0042768     1.78   0.075    -.0007657    .0159996
             198243  |   .0029559    .007769     0.38   0.704    -.0122718    .0181835
             198279  |   .0086346   .0041672     2.07   0.038     .0004666    .0168026
             198387  |   .0050859   .0034758     1.46   0.143    -.0017268    .0118986
             198459  |    .014051   .0035752     3.93   0.000     .0070433    .0210586
             198468  |   .0032116   .0036876     0.87   0.384    -.0040163    .0104395
             198666  |   .0097372   .0033487     2.91   0.004     .0031735    .0163009
             198675  |   .0079706   .0056419     1.41   0.158    -.0030879     .019029
             198747  |   .0051972   .0031027     1.68   0.094    -.0008842    .0112787
             198828  |   .0103666   .0036195     2.86   0.004     .0032722     .017461
                     |
               _cons |    .131076   .0746065     1.76   0.079    -.0151567    .2773087
--------------------------------------------------------------------------------------
F test of excluded instruments:
  F(  1,    85) =    41.05
  Prob > F      =   0.0000
Sanderson-Windmeijer multivariate F test of excluded instruments:
  F(  1,    85) =    41.05
  Prob > F      =   0.0000



Summary results for first-stage regressions
-------------------------------------------

                                           (Underid)            (Weak id)
Variable     | F(  1,    85)  P-val | SW Chi-sq(  1) P-val | SW F(  1,    85)
CAO          |      41.05    0.0000 |       41.61   0.0000 |       41.05

NB: first-stage test statistics cluster-robust

Stock-Yogo weak ID F test critical values for single endogenous regressor:
                                   10% maximal IV size             16.38
                                   15% maximal IV size              8.96
                                   20% maximal IV size              6.66
                                   25% maximal IV size              5.53
Source: Stock-Yogo (2005).  Reproduced by permission.
NB: Critical values are for i.i.d. errors only.

Underidentification test
Ho: matrix of reduced form coefficients has rank=K1-1 (underidentified)
Ha: matrix has rank=K1 (identified)
Kleibergen-Paap rk LM statistic          Chi-sq(1)=30.99    P-val=0.0000

Weak identification test
Ho: equation is weakly identified
Cragg-Donald Wald F statistic                                    1377.11
Kleibergen-Paap Wald rk F statistic                                41.05

Stock-Yogo weak ID test critical values for K1=1 and L1=1:
                                   10% maximal IV size             16.38
                                   15% maximal IV size              8.96
                                   20% maximal IV size              6.66
                                   25% maximal IV size              5.53
Source: Stock-Yogo (2005).  Reproduced by permission.
NB: Critical values are for Cragg-Donald F statistic and i.i.d. errors.

Weak-instrument-robust inference
Tests of joint significance of endogenous regressors B1 in main equation
Ho: B1=0 and orthogonality conditions are valid
Anderson-Rubin Wald test           F(1,85)=        1.38     P-val=0.2431
Anderson-Rubin Wald test           Chi-sq(1)=      1.40     P-val=0.2366
Stock-Wright LM S statistic        Chi-sq(1)=     12.04     P-val=0.0005

NB: Underidentification, weak identification and weak-identification-robust
    test statistics cluster-robust

Number of clusters             N_clust  =         86
Number of observations               N  =      26888
Number of regressors                 K  =         53
Number of endogenous regressors      K1 =          1
Number of instruments                L  =         53
Number of excluded instruments       L1 =          1

IV (2SLS) estimation
--------------------

Estimates efficient for homoskedasticity only
Statistics robust to heteroskedasticity and clustering on numdep

Number of clusters (numdep) =       86                Number of obs =    26888
                                                      F( 52,    85) =    17.65
                                                      Prob > F      =   0.0000
Total (centered) SS     =  2294295.822                Centered R2   =   0.0043
Total (uncentered) SS   =  2298223.094                Uncentered R2 =   0.0060
Residual SS             =  2284527.843                Root MSE      =    9.218

--------------------------------------------------------------------------------------
                     |               Robust
tx_creationette_po~w |      Coef.   Std. Err.      z    P>|z|     [95% Conf. Interval]
---------------------+----------------------------------------------------------------
                 CAO |  -2.111975   1.779066    -1.19   0.235     -5.59888     1.37493
             coastal |   .3386347   .7208733     0.47   0.639    -1.074251     1.75152
     log_hotel_rooms |    .300075   .0919413     3.26   0.001     .1198734    .4802766
        log_tot_pop_ |   .0893368   .0537424     1.66   0.096    -.0159965      .19467
   delta_log_tot_pop |   1.003192   .6686129     1.50   0.134    -.3072657    2.313649
 log_min_dist_center |  -.4183177   .1335926    -3.13   0.002    -.6801545    -.156481
volontaires_migrants |   .0443882   .3103295     0.14   0.886    -.5638465    .6526229
 evol_CADA_2012_2016 |  -.0094862   .0110853    -0.86   0.392     -.031213    .0122405
         share_0014_ |  -3.885217   2.504926    -1.55   0.121    -8.794781    1.024348
          share_60p_ |  -3.101524   1.935639    -1.60   0.109    -6.895307    .6922588
    delta_share_0014 |   1.047102   2.170016     0.48   0.629    -3.206051    5.300254
     delta_share_60p |   .4010099   1.865653     0.21   0.830    -3.255603    4.057623
         share_csp1_ |  -.4694306     1.9759    -0.24   0.812    -4.342124    3.403262
         share_csp2_ |  -5.451028   2.916336    -1.87   0.062    -11.16694    .2648861
         share_csp3_ |  -.6417107   2.216274    -0.29   0.772    -4.985527    3.702106
         share_csp4_ |  -1.097654   2.120513    -0.52   0.605    -5.253782    3.058474
         share_csp5_ |  -3.900865    2.01802    -1.93   0.053    -7.856111    .0543808
         share_csp6_ |  -2.075129   1.733676    -1.20   0.231    -5.473072    1.322814
         share_csp7_ |  -.9029537   1.625588    -0.56   0.579    -4.089047     2.28314
         share_csp8_ |          0  (omitted)
    delta_share_csp1 |   2.506282    1.59747     1.57   0.117    -.6247016    5.637266
    delta_share_csp2 |   7.038002   2.342692     3.00   0.003      2.44641    11.62959
    delta_share_csp3 |     1.8639   1.846673     1.01   0.313    -1.755513    5.483312
    delta_share_csp4 |   1.327868   1.266322     1.05   0.294    -1.154078    3.809815
    delta_share_csp5 |   3.148084   1.364904     2.31   0.021      .472922    5.823246
    delta_share_csp6 |   .7670478   1.066582     0.72   0.472    -1.323414    2.857509
    delta_share_csp7 |   .3232234   1.124158     0.29   0.774    -1.880085    2.526532
    delta_share_csp8 |          0  (omitted)
     share_chom1564_ |  -2.165066   2.590951    -0.84   0.403    -7.243236    2.913104
delta_share_chom1564 |  -.3162872   2.741914    -0.12   0.908    -5.690339    5.057765
           migshare_ |   .5544063   1.720492     0.32   0.747    -2.817695    3.926508
      delta_migshare |  -.0656132   6.015292    -0.01   0.991    -11.85537    11.72414
     log_median_inc_ |  -.1212026   .7935712    -0.15   0.879    -1.676574    1.434168
delta_log_median_inc |  -.7415039   .7780714    -0.95   0.341    -2.266496     .783488
             female_ |  -.0440806   .1860216    -0.24   0.813    -.4086762    .3205149
                age_ |    .006647   .0072749     0.91   0.361    -.0076116    .0209055
              right_ |  -.0078646   .1330026    -0.06   0.953    -.2685448    .2528156
           CSP_agri_ |   .0899033   .1613028     0.56   0.577    -.2262444    .4060509
            CSP_ind_ |   .0176201    .188986     0.09   0.926    -.3527857     .388026
            CSP_sal_ |   .3010712   .2410814     1.25   0.212    -.1714397    .7735821
            CSP_lib_ |   .3210743   .2404269     1.34   0.182    -.1501538    .7923024
            CSP_ens_ |   .0687452   .2669349     0.26   0.797    -.4544376    .5919281
           CSP_func_ |  -.0152779   .2311234    -0.07   0.947    -.4682715    .4377157
            CSP_div_ |   .1468845   .2092732     0.70   0.483    -.2632834    .5570524
           CSP_retr_ |          0  (omitted)
                     |
                 reg |
             198234  |  -.2190335    .407496    -0.54   0.591    -1.017711     .579644
             198243  |  -.5091679   .3172059    -1.61   0.108     -1.13088    .1125442
             198279  |  -.1645635   .3279769    -0.50   0.616    -.8073864    .4782594
             198387  |    .251735   .2533367     0.99   0.320    -.2447957    .7482657
             198459  |  -.0050232   .2992317    -0.02   0.987    -.5915066    .5814602
             198468  |  -.2341022   .2949688    -0.79   0.427    -.8122305     .344026
             198666  |   .1439624   .5326344     0.27   0.787    -.8999817    1.187907
             198675  |   .1515877    .259006     0.59   0.558    -.3560547      .65923
             198747  |    .095459   .3364146     0.28   0.777    -.5639015    .7548196
             198828  |  -.4937752   .3792844    -1.30   0.193    -1.237159    .2496086
                     |
               _cons |   4.994796   7.537906     0.66   0.508    -9.779228    19.76882
--------------------------------------------------------------------------------------
Underidentification test (Kleibergen-Paap rk LM statistic):             30.994
                                                   Chi-sq(1) P-val =    0.0000
------------------------------------------------------------------------------
Weak identification test (Cragg-Donald Wald F statistic):             1377.106
                         (Kleibergen-Paap rk Wald F statistic):         41.050
Stock-Yogo weak ID test critical values: 10% maximal IV size             16.38
                                         15% maximal IV size              8.96
                                         20% maximal IV size              6.66
                                         25% maximal IV size              5.53
Source: Stock-Yogo (2005).  Reproduced by permission.
NB: Critical values are for Cragg-Donald F statistic and i.i.d. errors.
------------------------------------------------------------------------------
Hansen J statistic (overidentification test of all instruments):         0.000
                                                 (equation exactly identified)
------------------------------------------------------------------------------
Instrumented:         CAO
Included instruments: coastal log_hotel_rooms log_tot_pop_ delta_log_tot_pop
                      log_min_dist_center volontaires_migrants
                      evol_CADA_2012_2016 share_0014_ share_60p_
                      delta_share_0014 delta_share_60p share_csp1_ share_csp2_
                      share_csp3_ share_csp4_ share_csp5_ share_csp6_
                      share_csp7_ delta_share_csp1 delta_share_csp2
                      delta_share_csp3 delta_share_csp4 delta_share_csp5
                      delta_share_csp6 delta_share_csp7 share_chom1564_
                      delta_share_chom1564 migshare_ delta_migshare
                      log_median_inc_ delta_log_median_inc female_ age_ right_
                      CSP_agri_ CSP_ind_ CSP_sal_ CSP_lib_ CSP_ens_ CSP_func_
                      CSP_div_ 198234.reg 198243.reg 198279.reg 198387.reg
                      198459.reg 198468.reg 198666.reg 198675.reg 198747.reg
                      198828.reg
Excluded instruments: num_group_vv
Dropped collinear:    share_csp8_ delta_share_csp8 CSP_retr_
------------------------------------------------------------------------------
 : 
. ****
. 
.  ivreg2  evol2_fn_2012_2017 (CAO= num_group_vv)  tx_creationette_post_new   coastal  log_hotel_rooms    log_tot_pop_ delta
> _log_tot_pop  log_min_dist_center volontaires_migrants evol_CADA_2012_2016 share_0014_   share_60p_  delta_share_0014 ///
>    delta_share_60p   share_csp1_ share_csp2_ share_csp3_ share_csp4_ share_csp5_ share_csp6_ share_csp7_ share_csp8_   del
> ta_share_csp* share_chom1564_ delta_share_chom1564 migshare_ delta_migshare ///
>    log_median_inc_ delta_log_median_in female_ age_ right_ CSP_agri_ CSP_ind_ CSP_sal_ CSP_lib_ CSP_ens_ CSP_func_ CSP_div
> _ CSP_retr_  i.reg, cluster( numdep) first
Warning - collinearities detected
Vars dropped:       share_csp8_ delta_share_csp8 CSP_retr_

First-stage regressions
-----------------------


First-stage regression of CAO:

Statistics robust to heteroskedasticity and clustering on numdep
Number of obs =                  26888
Number of clusters (numdep) =       86
------------------------------------------------------------------------------------------
                         |               Robust
                     CAO |      Coef.   Std. Err.      t    P>|t|     [95% Conf. Interval]
-------------------------+----------------------------------------------------------------
            num_group_vv |   .0046016   .0007182     6.41   0.000     .0031938    .0060094
tx_creationette_post_new |   .0000557   .0001085     0.51   0.608    -.0001569    .0002684
                 coastal |   .0208613   .0086689     2.41   0.016     .0038698    .0378529
         log_hotel_rooms |   .0045765   .0009784     4.68   0.000     .0026588    .0064942
            log_tot_pop_ |    .002406   .0011634     2.07   0.039     .0001257    .0046862
       delta_log_tot_pop |  -.0154329   .0068645    -2.25   0.025    -.0288877   -.0019781
     log_min_dist_center |  -.0065118   .0023985    -2.71   0.007    -.0112131   -.0018106
    volontaires_migrants |   .0809628   .0245543     3.30   0.001     .0328351    .1290906
     evol_CADA_2012_2016 |    .001849    .000552     3.35   0.001     .0007671     .002931
             share_0014_ |  -.0238287   .0264888    -0.90   0.368    -.0757481    .0280907
              share_60p_ |   -.015627    .017863    -0.87   0.382    -.0506394    .0193854
        delta_share_0014 |   .0258565   .0169091     1.53   0.126    -.0072863    .0589993
         delta_share_60p |    .000939   .0186721     0.05   0.960    -.0356592    .0375372
             share_csp1_ |   .0086171   .0202279     0.43   0.670    -.0310306    .0482649
             share_csp2_ |  -.0521017   .0281539    -1.85   0.064    -.1072849    .0030815
             share_csp3_ |  -.0209607   .0274622    -0.76   0.445    -.0747881    .0328666
             share_csp4_ |   .0127245   .0214098     0.59   0.552    -.0292399    .0546888
             share_csp5_ |  -.0086687   .0215583    -0.40   0.688    -.0509241    .0335867
             share_csp6_ |   .0091898   .0198286     0.46   0.643    -.0296753     .048055
             share_csp7_ |   .0012525   .0159178     0.08   0.937    -.0299472    .0324523
             share_csp8_ |          0  (omitted)
        delta_share_csp1 |  -.0231208   .0119658    -1.93   0.053    -.0465743    .0003327
        delta_share_csp2 |   .0151483   .0175915     0.86   0.389     -.019332    .0496285
        delta_share_csp3 |  -.0033493   .0169429    -0.20   0.843    -.0365582    .0298596
        delta_share_csp4 |  -.0273825   .0137034    -2.00   0.046     -.054242    -.000523
        delta_share_csp5 |  -.0078963   .0111859    -0.71   0.480    -.0298214    .0140287
        delta_share_csp6 |  -.0132454   .0125517    -1.06   0.291    -.0378474    .0113566
        delta_share_csp7 |   -.011672   .0100591    -1.16   0.246    -.0313884    .0080444
        delta_share_csp8 |          0  (omitted)
         share_chom1564_ |   .0444935   .0298057     1.49   0.136    -.0139272    .1029142
    delta_share_chom1564 |  -.0268731   .0243438    -1.10   0.270    -.0745882    .0208421
               migshare_ |   .0170658   .0282851     0.60   0.546    -.0383746    .0725061
          delta_migshare |   .0118551   .0393669     0.30   0.763    -.0653061    .0890163
         log_median_inc_ |  -.0115154   .0072088    -1.60   0.110    -.0256451    .0026142
    delta_log_median_inc |  -.0078562   .0063265    -1.24   0.214    -.0202565    .0045441
                 female_ |  -.0001524   .0016207    -0.09   0.925    -.0033289    .0030242
                    age_ |  -.0001668   .0001167    -1.43   0.153    -.0003955    .0000619
                  right_ |  -.0009641   .0012367    -0.78   0.436    -.0033881      .00146
               CSP_agri_ |  -.0002953   .0018492    -0.16   0.873    -.0039198    .0033293
                CSP_ind_ |  -.0023783   .0028996    -0.82   0.412    -.0080616    .0033051
                CSP_sal_ |  -.0029275   .0021821    -1.34   0.180    -.0072046    .0013496
                CSP_lib_ |   .0005142   .0051825     0.10   0.921    -.0096438    .0106722
                CSP_ens_ |   .0025596   .0040196     0.64   0.524     -.005319    .0104382
               CSP_func_ |  -.0038619   .0030545    -1.26   0.206    -.0098488    .0021251
                CSP_div_ |   .0040452   .0045324     0.89   0.372    -.0048386    .0129289
               CSP_retr_ |          0  (omitted)
                         |
                     reg |
                 198234  |     .00763   .0042753     1.78   0.074    -.0007498    .0160098
                 198243  |   .0029846   .0077657     0.38   0.701    -.0122365    .0182057
                 198279  |   .0086448   .0041614     2.08   0.038     .0004882    .0168014
                 198387  |   .0050724   .0034697     1.46   0.144    -.0017283    .0118732
                 198459  |   .0140529   .0035692     3.94   0.000     .0070571    .0210487
                 198468  |   .0032251   .0036831     0.88   0.381     -.003994    .0104441
                 198666  |   .0097303   .0033355     2.92   0.004     .0031925    .0162681
                 198675  |   .0079631   .0056384     1.41   0.158    -.0030884    .0190146
                 198747  |   .0051925   .0030942     1.68   0.093    -.0008722    .0112572
                 198828  |   .0103953   .0036251     2.87   0.004     .0032899    .0175007
                         |
                   _cons |   .1308131   .0745088     1.76   0.079     -.015228    .2768543
------------------------------------------------------------------------------------------
F test of excluded instruments:
  F(  1,    85) =    41.05
  Prob > F      =   0.0000
Sanderson-Windmeijer multivariate F test of excluded instruments:
  F(  1,    85) =    41.05
  Prob > F      =   0.0000



Summary results for first-stage regressions
-------------------------------------------

                                           (Underid)            (Weak id)
Variable     | F(  1,    85)  P-val | SW Chi-sq(  1) P-val | SW F(  1,    85)
CAO          |      41.05    0.0000 |       41.61   0.0000 |       41.05

NB: first-stage test statistics cluster-robust

Stock-Yogo weak ID F test critical values for single endogenous regressor:
                                   10% maximal IV size             16.38
                                   15% maximal IV size              8.96
                                   20% maximal IV size              6.66
                                   25% maximal IV size              5.53
Source: Stock-Yogo (2005).  Reproduced by permission.
NB: Critical values are for i.i.d. errors only.

Underidentification test
Ho: matrix of reduced form coefficients has rank=K1-1 (underidentified)
Ha: matrix has rank=K1 (identified)
Kleibergen-Paap rk LM statistic          Chi-sq(1)=30.98    P-val=0.0000

Weak identification test
Ho: equation is weakly identified
Cragg-Donald Wald F statistic                                    1377.38
Kleibergen-Paap Wald rk F statistic                                41.05

Stock-Yogo weak ID test critical values for K1=1 and L1=1:
                                   10% maximal IV size             16.38
                                   15% maximal IV size              8.96
                                   20% maximal IV size              6.66
                                   25% maximal IV size              5.53
Source: Stock-Yogo (2005).  Reproduced by permission.
NB: Critical values are for Cragg-Donald F statistic and i.i.d. errors.

Weak-instrument-robust inference
Tests of joint significance of endogenous regressors B1 in main equation
Ho: B1=0 and orthogonality conditions are valid
Anderson-Rubin Wald test           F(1,85)=       14.16     P-val=0.0003
Anderson-Rubin Wald test           Chi-sq(1)=     14.35     P-val=0.0002
Stock-Wright LM S statistic        Chi-sq(1)=     25.39     P-val=0.0000

NB: Underidentification, weak identification and weak-identification-robust
    test statistics cluster-robust

Number of clusters             N_clust  =         86
Number of observations               N  =      26888
Number of regressors                 K  =         54
Number of endogenous regressors      K1 =          1
Number of instruments                L  =         54
Number of excluded instruments       L1 =          1

IV (2SLS) estimation
--------------------

Estimates efficient for homoskedasticity only
Statistics robust to heteroskedasticity and clustering on numdep

Number of clusters (numdep) =       86                Number of obs =    26888
                                                      F( 53,    85) =    30.00
                                                      Prob > F      =   0.0000
Total (centered) SS     =  861.9605435                Centered R2   =   0.0754
Total (uncentered) SS   =  1998.702832                Uncentered R2 =   0.6013
Residual SS             =  796.9395876                Root MSE      =    .1722

------------------------------------------------------------------------------------------
                         |               Robust
      evol2_fn_2012_2017 |      Coef.   Std. Err.      z    P>|z|     [95% Conf. Interval]
-------------------------+----------------------------------------------------------------
                     CAO |  -.1198963   .0394039    -3.04   0.002    -.1971265   -.0426661
tx_creationette_post_new |    .000122   .0001256     0.97   0.331    -.0001241    .0003682
                 coastal |  -.0297199   .0114922    -2.59   0.010    -.0522443   -.0071955
         log_hotel_rooms |  -.0037652   .0012245    -3.07   0.002    -.0061652   -.0013653
            log_tot_pop_ |  -.0016354   .0019537    -0.84   0.403    -.0054646    .0021938
       delta_log_tot_pop |   .0168568   .0176685     0.95   0.340    -.0177728    .0514865
     log_min_dist_center |   .0060022   .0032094     1.87   0.061    -.0002881    .0122925
    volontaires_migrants |   .0069846     .01084     0.64   0.519    -.0142614    .0282306
     evol_CADA_2012_2016 |   .0003928   .0001669     2.35   0.019     .0000657      .00072
             share_0014_ |   .1600073   .0958283     1.67   0.095    -.0278127    .3478272
              share_60p_ |   .0647313   .0554937     1.17   0.243    -.0440343     .173497
        delta_share_0014 |   .0985433   .0513628     1.92   0.055     -.002126    .1992125
         delta_share_60p |   -.191832   .0552981    -3.47   0.001    -.3002142   -.0834498
             share_csp1_ |  -.3160567   .0902522    -3.50   0.000    -.4929477   -.1391656
             share_csp2_ |   -.388787   .0921213    -4.22   0.000    -.5693415   -.2082325
             share_csp3_ |  -.4725425   .0751499    -6.29   0.000    -.6198336   -.3252513
             share_csp4_ |  -.1539246    .063241    -2.43   0.015    -.2778746   -.0299746
             share_csp5_ |   .0461733   .0587634     0.79   0.432    -.0690008    .1613474
             share_csp6_ |    .099307   .0555563     1.79   0.074    -.0095814    .2081954
             share_csp7_ |  -.0554732     .05379    -1.03   0.302    -.1608996    .0499532
             share_csp8_ |          0  (omitted)
        delta_share_csp1 |   .2067877   .0670288     3.09   0.002     .0754136    .3381618
        delta_share_csp2 |   .2073288    .070652     2.93   0.003     .0688534    .3458041
        delta_share_csp3 |   .2409454   .0565368     4.26   0.000     .1301354    .3517554
        delta_share_csp4 |   .0915634   .0464409     1.97   0.049     .0005408    .1825859
        delta_share_csp5 |   .0016894   .0396062     0.04   0.966    -.0759372    .0793161
        delta_share_csp6 |  -.0181404   .0419876    -0.43   0.666    -.1004347    .0641538
        delta_share_csp7 |    .040591   .0401226     1.01   0.312    -.0380479    .1192298
        delta_share_csp8 |          0  (omitted)
         share_chom1564_ |    .186098   .1104709     1.68   0.092    -.0304209    .4026169
    delta_share_chom1564 |  -.0131702   .0753186    -0.17   0.861    -.1607919    .1344515
               migshare_ |  -.2240891   .0730632    -3.07   0.002    -.3672903   -.0808879
          delta_migshare |   .1118679   .1075425     1.04   0.298    -.0989115    .3226473
         log_median_inc_ |  -.0313288   .0271224    -1.16   0.248    -.0844877    .0218301
    delta_log_median_inc |  -.0070411   .0297237    -0.24   0.813    -.0652985    .0512163
                 female_ |  -.0005541   .0037679    -0.15   0.883     -.007939    .0068309
                    age_ |  -.0002448   .0001321    -1.85   0.064    -.0005037    .0000141
                  right_ |  -.0135153   .0029187    -4.63   0.000    -.0192358   -.0077948
               CSP_agri_ |   .0042709   .0042065     1.02   0.310    -.0039736    .0125154
                CSP_ind_ |   .0063314   .0044361     1.43   0.154    -.0023632     .015026
                CSP_sal_ |   -.004263   .0039312    -1.08   0.278    -.0119681    .0034421
                CSP_lib_ |   .0022817   .0051183     0.45   0.656    -.0077501    .0123134
                CSP_ens_ |  -.0021991   .0045778    -0.48   0.631    -.0111714    .0067732
               CSP_func_ |  -.0031839    .004495    -0.71   0.479     -.011994    .0056261
                CSP_div_ |   .0056332   .0059874     0.94   0.347    -.0061019    .0173683
               CSP_retr_ |          0  (omitted)
                         |
                     reg |
                 198234  |  -.0765619   .0130289    -5.88   0.000     -.102098   -.0510258
                 198243  |  -.0492989   .0160352    -3.07   0.002    -.0807273   -.0178706
                 198279  |  -.0698192   .0130231    -5.36   0.000    -.0953441   -.0442943
                 198387  |  -.0202063   .0244159    -0.83   0.408    -.0680607     .027648
                 198459  |  -.0506065   .0163321    -3.10   0.002    -.0826168   -.0185961
                 198468  |  -.0901302   .0124776    -7.22   0.000    -.1145858   -.0656745
                 198666  |  -.0572103   .0124222    -4.61   0.000    -.0815573   -.0328633
                 198675  |  -.1090152   .0307458    -3.55   0.000    -.1692758   -.0487545
                 198747  |  -.0545844   .0154916    -3.52   0.000    -.0849475   -.0242214
                 198828  |  -.0597762   .0123396    -4.84   0.000    -.0839614    -.035591
                         |
                   _cons |   .6078205   .2759456     2.20   0.028     .0669769    1.148664
------------------------------------------------------------------------------------------
Underidentification test (Kleibergen-Paap rk LM statistic):             30.983
                                                   Chi-sq(1) P-val =    0.0000
------------------------------------------------------------------------------
Weak identification test (Cragg-Donald Wald F statistic):             1377.382
                         (Kleibergen-Paap rk Wald F statistic):         41.049
Stock-Yogo weak ID test critical values: 10% maximal IV size             16.38
                                         15% maximal IV size              8.96
                                         20% maximal IV size              6.66
                                         25% maximal IV size              5.53
Source: Stock-Yogo (2005).  Reproduced by permission.
NB: Critical values are for Cragg-Donald F statistic and i.i.d. errors.
------------------------------------------------------------------------------
Hansen J statistic (overidentification test of all instruments):         0.000
                                                 (equation exactly identified)
------------------------------------------------------------------------------
Instrumented:         CAO
Included instruments: tx_creationette_post_new coastal log_hotel_rooms
                      log_tot_pop_ delta_log_tot_pop log_min_dist_center
                      volontaires_migrants evol_CADA_2012_2016 share_0014_
                      share_60p_ delta_share_0014 delta_share_60p share_csp1_
                      share_csp2_ share_csp3_ share_csp4_ share_csp5_
                      share_csp6_ share_csp7_ delta_share_csp1 delta_share_csp2
                      delta_share_csp3 delta_share_csp4 delta_share_csp5
                      delta_share_csp6 delta_share_csp7 share_chom1564_
                      delta_share_chom1564 migshare_ delta_migshare
                      log_median_inc_ delta_log_median_inc female_ age_ right_
                      CSP_agri_ CSP_ind_ CSP_sal_ CSP_lib_ CSP_ens_ CSP_func_
                      CSP_div_ 198234.reg 198243.reg 198279.reg 198387.reg
                      198459.reg 198468.reg 198666.reg 198675.reg 198747.reg
                      198828.reg
Excluded instruments: num_group_vv
Dropped collinear:    share_csp8_ delta_share_csp8 CSP_retr_
------------------------------------------------------------------------------

. 
. qui outreg2 using "Table 4", ///
> keep(CAO tx_creationette_post_new) ctitle(IV, , all controls, regions FE) bdec(3) nocons excel tex addstat(F-statistic, e(
> widstat)) `append'
 : 
. 
.  
.  restore

.  
.  log close
      name:  <unnamed>
       log:  D:\Dropbox\Migration and Extreme Votes in France - Max & Paul\Data and Codes for submission - PSRM\Table 4.log
  log type:  text
 closed on:   1 Feb 2022, 16:50:31
----------------------------------------------------------------------------------------------------------------------------
